<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>${tblName}属性</title>
<%@include file="../../common/tagInclude.jsp" %>
<%@include file="../../common/headerInclude.jsp" %>
<script type="text/javascript">
$(function() {
	$("#jvForm").validate();
});
</script>
</head>
<body>
<div class="body-box">
	<div class="rhead">
		<div class="rpos">当前位置: 首页 - 系统 - 数据库 - ${tblName}属性</div>
		<div class="clear"></div>
	</div>
	<form method="post" action="${basePath}admin/dbTable/queryTable.do" id="jvForm">
		<input type="hidden" name="tblName" id="tblName" value="${tblName}">
		<table width="100%" class="pn-ftable" cellpadding="2" cellspacing="1" border="0">
			<tbody>
			<tr>
				<td colspan="2" class="pn-fbutton">
					<textarea cols="70" rows="5" name="sql" id="sql" class="required">select * from ${tblName} limit 0,15</textarea>
				</td>
			</tr>
			<tr>
				<td colspan="2" class="pn-fbutton">
					<input type="submit" value="查&nbsp;&nbsp;询">
				</td>
			</tr>
			</tbody>
		</table>
	</form>
	<table class="pn-ltable" style="" width="100%" cellspacing="1" cellpadding="0" border="0">
		<thead class="pn-lthead">
		<tr>
			<th>Field</th>
			<th>Type</th>
			<th>Null</th>
			<th>Key</th>
			<th>Default</th>
			<th>Extra</th>
		</tr>
		</thead>
		<tbody class="pn-ltbody">
		<c:forEach items="${tableDescs}" var="table" varStatus="status">
		<tr>
			<td>${table.field}</td>
			<td>${table.type}</td>
			<td>${table.isNull}</td>
			<td>${table.key}</td>
			<td>${table.isDefault }</td>
			<td>${table.extra}</td>
		</tr>
		</c:forEach>
		</tbody>
	</table>
</div>
</body>
</html>